package cn.cvs.dao;

import cn.cvs.pojo.StorageRecord;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StorageRecordMapper {
/*    //查询入库记录
    public List<StorageRecord> getStorageRecordListByT(@Param("name")String name,@Param("sId")Integer sId,@Param("sStatus")Integer sStatus);
    //查询信息并显示供货商名称
    public List<StorageRecord> getStorageRecordByT1(StorageRecord user);
    //两表查询信息
    public List<StorageRecord> getStorageRecordAndSupplier();*/



    /*---*/
    //添加信息
    public int addStorageRecord(StorageRecord storageRecord);
    //删除信息
    public int delStorageRecord(Integer id);
    //修改
    public int updStorageRecord(StorageRecord storageRecord);
    //根据供货商id查询
    public int getStorageRecordBySupplierId(Integer supplierId);

    //if动态查询
    public int getStorageRecordByIf(@Param("supplierId")Integer id
            ,@Param("payStatus")Integer pay
            ,@Param("goodsName")String name);
    //分页查询
    public List<StorageRecord> getListByPage(@Param("supplierId")Integer id
            ,@Param("payStatus")Integer pay
            ,@Param("goodsName")String name
            ,@Param("pageIndex")Integer pageIndex
            ,@Param("pageSize")Integer pageSize);
    //根据入库id查询信息
    public StorageRecord getStorageById(Integer storageId);


}
